-
Is there a "user_tables" in SQL like in Oracle?
Anyone know if there's a system resource like in Oracle where you can SELECT tablename FROM user_tables? I know there must be. I just want to make a simple report listing all 100+ tables in a DB and their recordcounts.
-
Is there a "user_tables" in SQL like in Oracle? (reply)
Yes, run the query:
select name, * from sysobjects where type = 'u' order by name
------------
Greg Luce at 12/7/2001 9:15:44 AM
Anyone know if there's a system resource like in Oracle where you can SELECT tablename FROM user_tables? I know there must be. I just want to make a simple report listing all 100+ tables in a DB and their recordcounts.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|